--- ATUALIZAR LIMITE 250 VENDEDORES ---

SELECT CODIGO_CLIENTE, CLIENTE_VAREJO,LIMITE_CREDITO, LIMITE_CREDITO_TOTAL, STATUS FROM CLIENTES_VAREJO 
WHERE CODIGO_CLIENTE IN ('9210','9670','A547','C967','D047','D098','X590','A758','C329','C347','C826','C914','C915','C988',
'D030','D178','X462','B273','C364','C388','C505','C600','C850','C853','8932','B646','B847','C225','C303','C439','C452','C868',
'C244','C494','C496','X102','B091','C495','C954','D037','X419','X431','B948','C273','C331','C854','C991','X657','2647','2850',
'6277','B304','C316','C381','X461','X793','B287','B291','B540','A749','C193','C355','C852','D068','D190','X576','X579','1188',
'1215','1229','1242','1259','1330','1331','1628','2381','A777','C858','X641','C507','C591','C598','C624','8987','9012','B661',
'C351','C997','9878','B675','B776','B778','C792','D031','D055','C005','C117','C337','C635','A948','7020','B835','C674','X427',
'X863','B212','B876','C564','C734','A673','C217','9853','A072','C793','C877','X776','C196','C346','X613','X627','X868','8262',
'A659','C862','C004','C135','C203','A762','B815','C827','X712','A947','C687','X405','B387','B740','X626','X673','X682','X849',
'9639','B382','C011','C133','C267','C562','B827','X496','B473','B622','C397','D023','X895','A259','B156','B927','X750','7231',
'8510','D029','A895','B289','B919','C625','D077','D078','D088','D163','X549','B581','C375','A680','C906','C913','C936','D075',
'C422','C548','C829','D074','X785','8574','9766','B278','B416','C336','B355','C324','C328','C787','C979','A617','B372','C499',
'C501','C515','D039','9604','B651','C962','C963','C968','B940','C482','B269','C481','X696','B078','B454','C073','C120','X504',
'8385','9440','B422','D079','D110','X557','B470','B564','C205','D092','X489','B692','C706','9112','C867','X499','9767','C181',
'C628','7623','C119','X740','8635','8636','8748','9652','C211','X492','C228','C449','C721','X888','4889','8123','9889','A248',
'B588','B843','C846','C896','C952','X809','8968','B176','B567','C053','C545','3802','A770','B613','D042','D070','7040','A678',
'B247','B313','B565','B769','C406','D040','X277','B170','B719','B972','C186','C266','X148','C256','X494','X828','B557','A518',
'C070','D007','X479','X585','4665','1914','4013','4675','4676','3558','B383','B727','C879','D160','D161','D162','9367','9667',
'B659','B824','B899','B953','C192','D026','X565','X661','7693','C051','C341','C924','C934','8772','C068','C278','C485','C702',
'C823','X529','B072','B393','B608','B725','C883','X570','8920','B405','B737','B873','C314','C484','C919','6888','7232','B308',
'B589','B816','C274','A599','X536','X860','9838','D051','D193','9821','B979','C210','C675','C995','X737','1275','1327','1626',
'1629','B829','C872','D080','D121','X562','B274','C885','B108','B347','9362','C067','C841','B724','C993','D011','X631','C043',
'C249','C483','X387','X687','X692','7961','B883','C457','C486','C887','C365','X791','X859','C808','8630','B929','C518','X321',
'X503','8993','B207','C664','C519','8752','9778','8238','9601','B556','A572','B380','B650','C301','X236','C095','C946','D104',
'C528','C596','C815','C869','C901','C102','A621','C305','C966','9720','B918','B957','X653','B329','C813','D123','D124','8893',
'A350','7618','8620','8678','C938','C977','A480','B546','B931','C718','X841','C323','D185','D194','C258','C800','C889','B754',
'C327','C459','X132','9499','B302','B576','C837','9599','B794','C969','D069','X323','9469','C032','C312','C700','C727','D035',
'D045','C289','B199','X620','X621','A980','C035','C168','C306','C402','C438','C667','C845','C982','C731','B506','C361','X672',
'8048','B678','C717','D067','A937','B085','B656','B900','C546','C978','B707','B709','B711','C713','8334','C890','X779','C840',
'C980','D056','X830','X276','X353','C960','B943','C751','C755','C757','C759','C761','C656','D081','B821','D001','D003','D008',
'D181','X819','B880','C497','C597','D028','9520','9960','C354','2795','C260','C843','C875','C927','C928','C602','C261','C825',
'D177','A558','C322','C401','C580','X588','B965','C898','D058','D062','D063','D064','X157','C642','C646','C866','C917','X745',
'9827','C576','D202','D203','D204','D205','D206','C701','C911','C925','D076','X416','B298','B479','C374','X446','C849','C931',
'D022','7084','B597','B809','B997','C087','X209','X541','2301','C525','C786','C818','B514','B755','B966','C318','C326','C590',
'C719','B331','B958','C810','C921','X852','B424','C263','9159','D066','X609','A564','C685','C920','B469','B885','C209','C603',
'C649','C943','C951','D013','C992','D025','X007','X100','7162','A813','B442','C468','D046','B545','C139','C817','D100','D101',
'X076','8978','A896','B282','B614','B643','C132','X248','C321','C661','C893','C985','B734','B858','B970','C430','1672','8952',
'9137','B571','C008','C856','B851','C688','C882','D009','D034','X581','B466','C834','C870','C910','1148','2036','2551','9957',
'C831','D106','X683','C198','C376','D024','X658','C631','C587','X664','X846','B194','B480','B954','C565','X762','B690','C014',
'C689','C711','C208','C888','C964','C523','B890','C061','C860','A524','B596','C692','7350','X733','2315','2964','3240','2046',
'2827','2896','2903','A506','A619','B254','B591','B712','B713','C195','D015','B338','B385','B449','B886','C821','C987','X678',
'B757','C595','X684','91','C064','C956','2087','3062','C313','B392','B559','B665','B674','9228','7902','7376','7377','7379',
'7947','7950','7951','8832','8917','8885','A418','B134','B137','B138','B139','B140','B141','B143','B657','B703','B704','B705',
'X298','X299','X300','A614','A615','D143','D144','D145','D146','D147','D149','D150','D151','D152','D153','D186','D200','B180',
'B181','B182','B183','B049','D089','D138','A749','D101','A659','C862','C196','C346','8262','B383','D160','D161','D162','C623',
'B274','B273','B678','B360','X805','C699','B906','D084','D109','D255','D254','D242','D243','D244','D245','D246','D247','D248',
'd258','d259','d260','d261','d262','d073','d134','D275','D276','D277','D278','D279','D280','D281','D284','D287','D288')and status = '1'

SELECT * FROM LOJA_VENDEDORES WHERE VENDEDOR = 'B073'

/* 
UPDATE CLIENTES_VAREJO  SET LIMITE_CREDITO_TOTAL = '250.00' 
WHERE CODIGO_CLIENTE IN ('D275','D276','D277','D278','D279','D280','D281','D284','D287','D288')
/*

UPDATE CLIENTES_VAREJO  SET STATUS = '1'
WHERE CODIGO_CLIENTE IN ('8048','8630','8993','a072','a506','b273','c656','c661')